#! python3
# -*- coding: utf-8 -
'''
Created on 2017年05月10日
@author: zxyong 13738196011
'''

import urllib.parse,json
from com.zxy.common import Com_Para
from com.zxy.common.Com_Fun import Com_Fun
from com.zxy.model.Return_Value import Return_Value
from com.zxy.adminlog.UsAdmin_Log import UsAdmin_Log
from _operator import length_hint
import sys,csv,re
import collections as col
from openpyxl import load_workbook
class ExcelUtil(object):
    def __init__(self):
        pass
    def readExcel(self,inputExcelName):
        fp = '/home/hadoop/同义词.xlsx'
        ws = load_workbook(fp)
        sheet = ws.get_sheet_by_name("sheet1")
        for i in  sheet.rows:
            a = i[0].value if i[0].value != None else '' #如果单元格的值为空，则空串
            b = i[1].value if i[1].value != None else ''
            c = i[2].value if i[2].value != None else ''